# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月21日
"""
import openpyxl

myBook = openpyxl.load_workbook('新书订购表.xlsx', data_only=True)
mySheet = myBook.active

myImage1=openpyxl.drawing.image.Image('images/myImage1.jpg')
mySheet.add_image(myImage1,'A5')
myImage2=openpyxl.drawing.image.Image('images/myImage2.jpg')
mySheet.add_image(myImage2,'B5')

myBook.save('结果表-新书订购表.xlsx')
